database problem

Results 1 to 2 of 2

Thread: database problem

  1. #1
    Join Date
    Dec 1969

    Default database problem

    Dear all,<BR>I am not sure about this. I need to derive info from two tables. Can I have complex SQL queries in the cmd.commandtext like select * from table1, table2<BR>where table1.col1==table2.col1.<BR>Also, how do I get a particular value from one table into a variable so that I<BR>can search this variable value against values in other tables.<BR>Thanks in advance,<BR>~ Sonu

  2. #2
    Join Date
    Dec 1969

    Default RE: database problem

    R&D Joins:<BR><BR>SELECT * FROM Table1 T1<BR>INNER JOIN Table2 T2 On T1.Col1 = T2.Col1<BR><BR>For the second question: which db do you use, if it&#039;s SQL Server you could do it really good in an stored proc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts