Mariacust must be included in you FROM list:
SELECT ...
FROM customers, mariacust
WHERE ...
-----Original Message-----
From: Armando Cerna [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 12:16 PM
To: [EMAIL PROTECTED]
Subject: Help!
I try the following command, and get that error every time:
mysql> select company, tele, contact, mariacust.comments
-> from
-> customers where tele = mariacust.tele GROUP BY company;
ERROR 1109: Unknown table 'mariacust' in field list
mysql>
And yes... the talbe exists.
mysql> show tables;
+-----------------+
| Tables_in_maria |
+-----------------+
| cathycust |
| customers |
| inventory |
| invoices |
| mariacust |
| salesid |
+-----------------+
6 rows in set (0.00 sec)
I don't quite understand why this happens since everything exists
Armando
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
