I have a table with a set of 2 groups of information. e.g.
The data is unrelated however I need to fetch a pair of 1 from each group as a row. thustable: field1 field2
apple 2
bat 1
pear 2
ball 1
[sql]SELECT a.field1, b.field1 FROM TABLE AS a LEFT JOIN TABLE AS b ON b.field2 = 2 WHERE a.field2 = 1[/sql]
NOW if i was to put LIMIT 1 this would have been cool. However for a limit of lets say 5 I would only get 1 result from the JOIN being REPEATED thus
WHAT do I need to do in order to getbat apple....bat pear
bat apple.....ball pear