mahmud_uk

mahmud_uk

  • NA
  • 48
  • 0

SQL query

Aug 27 2004 5:42 AM
i have two database table, from one table i am selecting all fields to be displayed on a form. From another database i'm trying to display just one field. Both database use delegation to relate to each other. Instead of writting another sql query out i was hoping will it be possible to merge the present query and retrive the data from the seceond query. this is how the first one is done: String sQuery = "SELECT * FROM License WHERE Name = '"+ label1.Text +"' AND LicenseGroupID = '"+ label2.Text +"'"; now i'm trying to retrive the LicenseGroup Name from the table LicenseGroup. I dont want to write another query out. as you can see LicenseGroupID is used on both table to match fields to each other. Is there any way i could use a combination factor tin the script to retrive the name from licengroup table. Thanks Mac

Answers (1)