SELECT *
FROM Customers, Orders
WHERE Customers.CustomerID = Orders.CustomerID AND CustName = `CN`
what could be wrong with it please help thanks.
BTW its a recordsset that finds a customers order history.
The other thing to look at are what you have called the fields in the database, do they match up exactly with your script and are they of the same datatype. I have messed around for ages before now only to find i have made a spelling error.
And remember in ultra dev you may need to re apply the recordset.
And you may want to add parens around each of the = statements. It's a good habit to get into to avoid problems when you write more complex statements.
If any of the fields are the same in the two tables you may have a problem. You are selecting *.
From my experience the only problem he/she will have is that duplicate column names will be assigned a sort of numeric column name. For example, column0, column1.. and so on.
An important point to make here, IMO, is that we should always strive to use column names in a query instead of just *.
we should always strive to use column names in a query instead of just *
I totally agree. It may not appear to be a big deal on a small db but try the two on a db with several thousand records and you're likely to notice a big difference in speed.
Those look like accent marks, not typical quotes.
Actually, I think they are "backtick" marks and, yes, they make MySQL choke. For some reason, some "dump" programs use them and I always end up doing a search and replace. The key is (on a US keyboard), just to the left of the 1.
search for ` and replace with '
Tom
between the ; and the #
