List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:September 14 2001 1:23pm
Subject:Re: using LEFT JOINS
View as plain text  
Then add a language column and initialize it to the table name.


Deryck Henson wrote:

> Sure...
> 
> SQL Query:
> 
> SELECT * FROM asp, c, cpp, java, javascript, coldfusion, xml, pascal, vb,
> perl, cgi, php, assembly, python where user = '"&user&"'
> 
> (gets an ambiguous error and I know why)
> 
> Database structure (all tables the same)
> 
> Tables- ASP, C, CPP, Java, Javascript, Coldfusion, XML, VB, Pascal, Perl,
> CGI, PHP, Assembly, Python, dHTML
> 
> Columns- user text, email text, homepage text, code longtext, tutorial
> longtext, codetype enum ('file', 'file-sourcecode', 'tutorial',
> 'file-tutorial', 'sourcecode'), file_path text, title text, description
> text, codeid text, rating int, votes int, views bigint, date_created
> datetime, level enum ('all', 'novice', 'intermediate', 'advanced')
> 
> - Deryck H
> - http://www.comp-u-exchange.com
> ----- Original Message -----
> From: "Gerald Clark" <gerald_clark@stripped>
> To: "Deryck Henson" <ussj4gohan@stripped>
> Cc: "MySQL" <mysql@stripped>
> Sent: Thursday, September 13, 2001 10:00 AM
> Subject: Re: using LEFT JOINS
> 
> 
> 
>> Show us your table definitions, what you tried, and
>> what you think didn't work.
>> 
>> 
>> 
>> Deryck Henson wrote:
>> 
>> 
>>> Well, before I asked which joins to use and now I want to know how to
>> 
> use
> 
>>> the LEFT JOINS.  They would be quite useful on my site right now.  Any
>> 
> help
> 
>>> is appreaciated and dont say to read the manual cause Ive tried that and
>> 
> it
> 
>>> doesnt give a good enough explanation.  This will be very helpful when
>>> displaying my database tables.
>>> 
>>> - Deryck H
>>> - http://www.comp-u-exchange.com
>>> 
>>> 
>>> 
>>> ---------------------------------------------------------------------
>>> 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 <mysql-thread85402@stripped>
>>> To unsubscribe, e-mail
>> 
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> 
>>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>> 
>> 
>> --
>> Gerald L. Clark
>> gerald_clark@stripped


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
using LEFT JOINSDeryck Henson13 Sep
  • Re: using LEFT JOINSGerald Clark13 Sep
  • Re: using LEFT JOINSDeryck Henson14 Sep
    • Re: using LEFT JOINSPaul DuBois14 Sep
  • Re: using LEFT JOINSDeryck Henson14 Sep
    • Re: using LEFT JOINSPaul DuBois14 Sep
  • Re: using LEFT JOINSDeryck Henson14 Sep
  • Re: using LEFT JOINSDeryck Henson14 Sep
  • Re: using LEFT JOINSGerald Clark14 Sep
Re: using LEFT JOINSLoyd Goodbar14 Sep