Displaying 1 result from an estimated 1 matches for "farmer_id".
2006 Mar 08
12
best way to combine results from two tables
I want to combine a selection of data from two tables and display it as
list. Note that this isn''t a join.
i''m looking for something like this:
Table 1: Sheep
Name, Age, Farmer, etc. (sheep specific columns)
Table 2: Cows:
Name, Age, Farmer, etc. (cow specific columns)
For my display I nneed something like this:
Farmer Jone''s Livestock:
TYPE NAME AGE
Cow