at 11:50:01AM -0500, Greg Klaus wrote:
> Jake,
>
> Since I am running MySQL 3.23.5x, I cannot do subselects.
>
> I am able to do the following:
>
> SELECT * FROM Items_Pictures
>LEFT JOIN Items
> ON Items_Pictures.Items_ID = Items.Items_ID
>WHERE Ite
where p.id = c.id)
>
>
>
> Regards,
> Jake Johnson
> [EMAIL PROTECTED]
>
> --
> Plutoid - http://www.plutoid.com
> Shop Plutoid for the best prices on Rims and Car Audio Products
>
>
> On We
#x27;-p' option says to prompt for and use a password in order to connect.
> Before these tests, I had used following commands to setup password
>
> /usr/local/mysql/bin/mysqladmin -u root password
> /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password
>
>
--
Greg Klau
I am trying to delete some orphaned records in an old database on a
website that I've recently taken over. Although the website is php
driven, I am doing this manually in a mysql client.
Mysql 3.23.54
Tables:
Items:
Items_ID
Pictures:
Picture_ID
Items_ID
I want to get
