FUDforum: comp.lang.php » Confused about a MySQL Statement

Home » Imported messages » comp.lang.php » Confused about a MySQL Statement

Show: Today's Messages :: Polls :: Message Navigator

Confused about a MySQL Statement [message #173061]

Sat, 19 March 2011 21:05

Joe
Messages: 1
Registered: October 2011

Karma:

Junior Member

I am trying to get a list from one table, and using another table to
subtract from that list.

I am trying to us:

SELECT entry_id, entry.video_id, entry_book, entry_category, sort_cat,
entry_guard_fname, entry_guard_lname,
entry_fname, entry_lname
FROM entry, chosen
where sort_cat = 2
and entry.video_id in
(Select video_id from chosen where chosen_win = "")

Which gives me way too may results, 4,042.

The first part, comes up with 157 records, where the second part is
only 5. I want the final list to be 152.

I have hit a wall here, and not sure where to go next. Can anyone
help?

Report message to a moderator

[Message index]

		Confused about a MySQL Statement By: Joe on Sat, 19 March 2011 21:05
		Re: Confused about a MySQL Statement By: richard on Sat, 19 March 2011 21:11
		Re: Confused about a MySQL Statement By: Luuk on Sat, 19 March 2011 22:06
		Re: Confused about a MySQL Statement By: Captain Paralytic on Sat, 19 March 2011 22:15
		Re: Confused about a MySQL Statement By: Denis McMahon on Sun, 20 March 2011 16:58
		Re: Confused about a MySQL Statement By: Jerry Stuckle on Sun, 20 March 2011 17:10

Previous Topic:	$_POST not set on 404
Next Topic:	Stats comp.lang.php (last 7 days)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 17:45:11 GMT 2024

Total time taken to generate the page: 0.04174 seconds