Community discussion forum

select same record from multiple table

• • Reply

  1 year ago

  by binusarathomas07

  binusarathomas07

  , India

  Joined 2 years ago

  hi all,

  I have a pblm to select the same field namely tripid from multiple tables.

  Actually i want to exclude a tripid if it is in any of the table with same route.

  i need to check if it is in any of there is four tables tb1, tb2 tb3, tb4....

  can anybody help me....

  thank you

  Binu

  Report abuse
• • Reply

  1 year ago

  by sync_or_swim

  Rob Bickel

  S. Wales, United Kingdom

  Joined 4 years ago
  Hi, You will have to provide more information in order to receive a meaningful response, what exactly do your tables llok like?  Without seeing your table structure I would guess that you could use a NOT IN query, ie. select tripid from yourtable where tripid not in(select tripid from tb1) and tripid not in(select tripid from tb2) and tripid not in(select tripid from tb3) etc.. 
  
  I will try and help further if you give more information.
  Report abuse