table2 is apart of table1

Question

0.00/5 (No votes)

See more:

hello evry body
this my first question in codeproject

i have 2 tables ( table1 , table2 )

table2 is part of table1

i want to show data from table1 where are not in table2

sorry for my English

Posted 10-Feb-12 8:03am

Ahmed_online

Add a Solution

Comments

ZurdoDev 10-Feb-12 14:38pm

Several different ways to do that. You can do a WHERE NOT EXISTS or WHERE NOT IN but you need to get the SQL written and then we can help.

4 solutions

Solution 2

If you have

Table1
 id
 name

and

Table2
 id
 name

Then you can do

SQL

SELECT Table1.* FROM Table1
LEFT JOIN Table2 
   ON Table1.ID = Table2.ID and Table1.Name = Table2.Name
WHERE Table2.ID is NULL

Essentially you're saying "Try to Join table 1 and Table 2 based on similar rows, and only return those rows from Table1 that don't exist in Table2"

Posted 10-Feb-12 16:37pm

Chris Maunder772.7K

Comments

Espen Harlinn 11-Feb-12 6:13am

5'ed!

Solution 3

It's a simple task. Take a look at this article to learn everything about JOINs
Visual Representation of SQL Joins[^]
BTW it has the answer

Posted 10-Feb-12 16:57pm

thatraja

Comments

Espen Harlinn 11-Feb-12 6:13am

5'ed!

Solution 1

You want to filter your data. The obvious way to do that is to just change the SQL that fills table2, to only put the data you want in there. Otherwise, copy the data to a new source and filter it.

And welcome to Code Project.

Posted 10-Feb-12 10:23am

Christian Graus

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ahmed_online · Accepted Answer · 2012-02-11T10:16:00

Solution 4

thanks every one : i found the soulution with this query

SELECT * FROM Table1 WHERE ID NOT IN (SELECT ID FROM Table2)

Posted 11-Feb-12 10:16am

Ahmed_online

table2 is apart of table1

4 solutions

Solution 2

Solution 3

Solution 1

Solution 4

Add your solution here

Preview 0

table2 is apart of table1

4 solutions

Solution 2

Solution 3

Solution 1

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us