cms9651 — 2010-07-18T12:35:32-04:00 — #1
I need your help, this is my tables in db mysql:
I need this output:
Any help would be very much appreciated and many thanks to any who can help me.
Thanks in advance.
cms9651 — 2010-07-22T07:54:02-04:00 — #2
Really thanks for your suggestion.
You understand my problem:
SELECT * FROM do_tableB AS o
LEFT JOIN do_tableA AS c ON c.NAME = o.NAME
WHERE c.NAME IS NULL
ORDER BY ID ASC
Learn to use the names do_tableA and do_tableB «copying» for your replies in this forum...
guelphdad — 2010-07-18T21:48:07-04:00 — #3
I guessed at everything in table B that wasn't in table A.
But very poor description of the problem.
I'm with ya on that last post though, Hi Viki!
r937 — 2010-07-18T20:27:02-04:00 — #4
all i'm saying is that the sample data sucks
it is not at all clear what is required here
ibazz — 2010-07-18T20:14:36-04:00 — #5
You'll need either to show other data that relate the data in the two tables or explain better what you are trying to do.
BTW, are you the same poster using a different name?
r937 — 2010-07-18T20:39:00-04:00 — #6
the "do_table" schema belongs to our old friend viki1967
considering all the trouble "viki" had with sql, i'm not surprised if she came back as a different member like "chevy"
r937 — 2010-07-18T19:13:35-04:00 — #7
how the heck does 1 KEVIN plus 1 HUMPREY produce 1 HUMPREY, and 4 ROBERT plus 4 MARGOT produce 4 MARGOT, but 3 CINDY plus 3 LAURA doesn't produce anything???
the sample data sucks
wolf_22 — 2010-07-18T19:49:42-04:00 — #8
So are you saying that it can't be done?
guelphdad — 2010-07-18T13:51:22-04:00 — #9
do a left join, start with table B and check for nulls