Two tables....

[kiss07]

Hi friends,

I have Two Three tables are there, Some records are same in all
the three tables , How i retrieve the same records in three table.

pls anybody send query.

Thanks,
Kiss07.

[bartonc]

Hi friends,

I have Two Three tables are there, Some records are same in all
the three tables , How i retrieve the same records in three table.

pls anybody send query.

Thanks,
Kiss07.

First:
The key is to use "normal form" so data is not duplicated in tables. Then your queries JOIN tables to get the data you want. This the whole point in using a RDBM. This is a must when it comes time to UPDATE your tables.
Any beginning SQL book will teach normalization.

Second:
If you want help with queries, you must post your table structure.

[bartonc]

Hi friends,

I have Two Three tables are there, Some records are same in all
the three tables , How i retrieve the same records in three table.

pls anybody send query.

Thanks,
Kiss07.

Here is a pdf tutorial that I just dug up for another member.

[kiss07]

Dear Bortonc,

Thanks for ur reply.

kiss07

[kiss07]

Dear Friend,.

This is my table Structure.

Emp:

Name dept salary
Clement Analayst $200
Louis Admin $230

Emp2:

Name dept salary
Clement Analayst $200
abraham tester $150


Emp3:

Name dept salary
Clement Analayst $200
John Programmer $500


I want first record of each table.. pls..

Kiss07

[bartonc]

Dear Friend,.

   This is my table Structure.
 
      Emp:
 
      Name                dept                   salary
     Clement           Analayst               $200
      Louis               Admin                  $230
 
     Emp2:
 
      Name                dept                   salary
     Clement           Analayst               $200
     abraham            tester                  $150
 
 
    Emp3:
 
      Name                dept                   salary
     Clement           Analayst               $200
     John                 Programmer          $500

I want first record of each table.. pls..

Kiss07

You can
SELECT Emp.Name, Emp2.Name FROM Emp, Emp2 WHERE Name = 'Clement';
but the results won't be very useful. This is due to poor table design. I suggest that you read up on normalization of you database tables.

[kiss07]

Dear Bortonc,

Thanku very much...


Kiss07

[bartonc]

Dear Bortonc,

Thanku very much...


Kiss07

You're welcome. I need the practice writing queries.