Hello!
I have a couple of tables I am doing a join on. Both have 6 fields.
Most fields have fewer than 16 characters in them, but at most 75.
Neither table is huge: one with 14004 rows and the other with 23677. I
created a temp table to insert the data into. When I perform the join,
it
You *are* getting both; you just aren't getting them in the same
result set.
Assuming you are executing both queries in the context of a program
that has
variables, that should be sufficient for you to do just about anything
you
can imagine.
Yeah, thought about that before I went to sleep. And,
Greetings, fellow MySQLers!
I know I ain't doing something right, but I don't know what. Say I have
a website. It has pages on it that get viewed. The hosting company
bills me each day for pages. So..
mysql select * from bill;
++--+
| amount | day |
++--+
| 1.10 | mon
The solution to your problem is simple: don't attempt to do the final
query.
Each of your existing queries are perfectly fine the way they are and
give
sensible and meaningful answers. Simply run the 3rd and 4th queries as
two
separate queries rather than trying to combine them into one query.