Grouping Question

I have a contact table looks like id type owner_idowner_type value 11email21 person [EMAIL PROTECTED] 12phone 21 person 303-777- 13PO Box18 business 220 14cell

one-to-one relation, foreign key creation

I want contacts to have a 1-1 relation to px_items. I'm hesitant to add the contact info onto px_items because uses that table. from phpMyAdmin, how would I re-organize things pls? Or, must I manually enter the SQL to establish the foreign key part? Once I have

Re: What is the equivalent of the minus function?

select email from participants minus select email from excluded Try an exclusion join (http://www.artfulsoftware.com, "The [Not] exists query pattern") ... select email from participants p left join excluded e on p.email=e.email where e.email is null; PB - Brian Menke wrote: I am try

Re: advice for blob tables?

Hi Michael, You are not the only one with this problem. We work in the print/ publishing sector and have many customers that need this type of functionality as well. So this is not going to help you right away, but we have consulted with MySQL and are starting an initiative for the impleme