Many to many

Results 1 to 2 of 2

Thread: Many to many

  1. #1
    Fred Guest

    Default Many to many

    I have a field on one table that contains a selection of numbers such as 1,2,4,6,7<BR>and another table the same sort of thing.... 6,3,5,2<BR>What I want to do is if a number in the first list appears in the second then tell me

  2. #2
    Join Date
    Dec 1969

    Default Like this...

    Select * from table1 where idfield in (select idfield from table2)<BR><BR>-- Whol

Posting Permissions

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