Help on database

Results 1 to 5 of 5

Thread: Help on database

  1. #1
    moti Guest

    Default Help on database

    I must do i page were i take information on the product from one table and i take also feedback on the product from other table how do i do it ?<BR>In one page ?<BR>Please help

  2. #2
    Join Date
    Dec 1969

    Default RE: Help on database

    You should do this <BR><BR>SELECT table1.product_name, FROM table1,table2<BR>WHERE (table1.[Id])=[table2].[Id]<BR><BR><BR>Hope this helps.<BR><BR>

  3. #3
    CAHEK & BAHEK Guest

    Default RE: Help on database

    Use INNER JOIN in your SQL statement<BR>Example:<BR>you have two Tables Customer and CustomerDetails<BR>Table Customer has two fields Cust_ID and Active<BR>Table CustomerDetails has following fields: ID,FN,LN<BR>SQL statement to show Details of Active customers:<BR>Select Customer.Cust_ID,CustomerDetails.FN,CustomerDetail s.LN<BR>from Customer inner join CustomerDetails<BR>on Customer.Cust_ID=CustomerDetails.ID<BR>Where Customer.Active=1<BR><BR>Enjoy your day ;)<BR><BR>

  4. #4
    moti Guest

    Default RE: Help on database

    Thanks i wil try

  5. #5
    moti Guest

    Default RE: Help on database

    Thnks to i will try it also

Posting Permissions

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