Newbie- Help with query

[Max Clark]

Help!

I am a new mysql user, I understand the basic syntax of the commands for different sql queries.

I am trying to write a query and I can't seem to figure it out. I would like to select all domain,transport fields from the transport table where the transport id = a query agains the acl table (select transportId from acl where adminId='1').

When I try this I get a sql error, what do I need to do differently?

Thanks in advance,
Max

mysql> describe transport;
+-----------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+----------------------+------+-----+---------+----------------+
| id | smallint(5) unsigned | | PRI | NULL | auto_increment |
| domain | char(50) | | UNI | | |
| transport | char(50) | | | | |
+-----------+----------------------+------+-----+---------+----------------+
3 rows in set (0.01 sec)

mysql> describe acl;
+-------------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------------------+------+-----+---------+----------------+
| id | smallint(5) unsigned | | PRI | NULL | auto_increment |
| adminId | smallint(5) unsigned | | | 0 | |
| transportId | smallint(5) unsigned | | | 0 | |
| securityId | smallint(5) unsigned | | | 0 | |
+-------------+----------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)




---------------------------------------------------------------------
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