TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
1
)
How to free a document?
disabling event and data binding