Re: Quick help with Insert

where b.lieferant is null -Ursprüngliche Nachricht- Von: Carlos Proal [mailto:carlos.pr...@gmail.com] Bereitgestellt: Dienstag, 19. Jänner 2010 20:15 Bereitgestellt in: gmane.comp.db.mysql.general Unterhaltung: Quick help with Insert Betreff: Re: Quick help with Insert Hi

Re: Quick help with Insert

Hey Not really quick ; - But nobody knows an answer? THX -Ursprüngliche Nachricht- Von: Intell! Soft [mailto:intellis...@fachoptiker.net] Bereitgestellt: Donnerstag, 14. Jänner 2010 17:40 Bereitgestellt in: gmane.comp.db.mysql.general Unterhaltung: Quick help with Insert Betreff

Re: Quick help with Insert

an answer? THX -Ursprüngliche Nachricht- Von: Intell! Soft [mailto:intellis...@fachoptiker.net] Bereitgestellt: Donnerstag, 14. Jänner 2010 17:40 Bereitgestellt in: gmane.comp.db.mysql.general Unterhaltung: Quick help with Insert Betreff: Quick help with Insert Hey I would need quick help

Re: Quick help with Insert

...@gmail.com] Bereitgestellt: Dienstag, 19. Jänner 2010 20:15 Bereitgestellt in: gmane.comp.db.mysql.general Unterhaltung: Quick help with Insert Betreff: Re: Quick help with Insert Hi !! You need a left join and then an insert. Please read: http://dev.mysql.com/doc/refman/5.1/en/join.html or google

Re: A quick help

harsh [EMAIL PROTECTED] wrote: Two databases data1 data2 data1 has table1 and data2 has table2 both the tables have uid field common I want to list out common uid's from table1 annd table2 Tried many commands as i understood from documentations but somewhere i m always wrong.

A quick help

Two databases data1 data2 data1 has table1 and data2 has table2 both the tables have uid field common I want to list out common uid's from table1 annd table2 Tried many commands as i understood from documentations but somewhere i m always wrong. thanks regards

Re: QUICK HELP, two selects, maybe nested.

Corey Kaye writes: Looking though the docs. MySQL does not support nested selects but i'm looking for a way to speed up my PHP. This is what i have: CREATE TABLE departmentuser ( userid int(10) unsigned zerofill default NULL, departmentid int(10) unsigned zerofill default NULL,

Re: QUICK HELP, two selects, maybe nested.

I looked that up and IN is an OR ... correct ? Would be like saying: Show me the records where departmentid = 142 OR departmentid = 368 I did however find this: select * from departmentuser r1, departmentuser r2 where r1.userid=r2.userid and r1.departmentid=368 and r2.departmentid=142;