esigns.com]
> Sent: April 26, 2010 10:29 PM
> To: mysql@lists.mysql.com
> Subject: Re: Join syntax problem
>
> Thanks for the replies. It was my understanding that whitespace is
> ignored,
> and I did not think that not having space, in particular with "." wou
Thanks for the replies. It was my understanding that whitespace is ignored,
and I did not think that not having space, in particular with "." would
result in an error message.
Gary
""Gary"" wrote in message
news:20100426233621.10789.qm...@lists.mysql.com...
I cant seem to get this working.
I am reading this on a tiny screen but it looks like you need
whitespace before the where.
On 4/26/10, Gary wrote:
> I cant seem to get this working.
>
> $query="SELECT im.image_id, im.caption, im.where_taken, im.description,
> im.image_file, im.submitted, kw.fox, kw.wolves, kw.wildlife, kw.ameri
On 4/26/10 7:36 PM, "Gary" wrote:
> I cant seem to get this working.
>
> $query="SELECT im.image_id, im.caption, im.where_taken, im.description,
> im.image_file, im.submitted, kw.fox, kw.wolves, kw.wildlife, kw.american,
> kw.scenic, kw.birds, kw.africa, kw.eagles, kw.hunter" .
> "FROM *images A
I cant seem to get this working.
$query="SELECT im.image_id, im.caption, im.where_taken, im.description,
im.image_file, im.submitted, kw.fox, kw.wolves, kw.wildlife, kw.american,
kw.scenic, kw.birds, kw.africa, kw.eagles, kw.hunter" .
"FROM *images AS im"."JOIN keywords AS kw USING (image_id)" .
.mysql.com
From: Chris White <[EMAIL PROTECTED]>
Subject: Re: Problem With Join Syntax
On Wednesday 14 June 2006 10:55 am, Albert Padley wrote:
A typical set of data looks like this:
id | inputfieldid | userid | value
1 1 2 John
2 2 2 Sm
2006, Chris White wrote:
> To: mysql@lists.mysql.com
> From: Chris White <[EMAIL PROTECTED]>
> Subject: Re: Problem With Join Syntax
>
> On Wednesday 14 June 2006 10:55 am, Albert Padley wrote:
> > A typical set of data looks like this:
> >
> > id | inputfi
Dan,
Thanks. I'll take a further look at GROUP_CONCAT.
Albert
On Jun 14, 2006, at 1:16 PM, Dan Buettner wrote:
Albert, MySQL's GROUP_CONCAT function might work for you:
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
In your case something like this:
SELECT userid, GROUP_CON
Albert, MySQL's GROUP_CONCAT function might work for you:
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
In your case something like this:
SELECT userid, GROUP_CONCAT(value)
GROUP BY userid
HTH,
Dan
Albert Padley wrote:
I have the following table schema in MySQL 4.1.18 which I
On Wednesday 14 June 2006 10:55 am, Albert Padley wrote:
> A typical set of data looks like this:
>
> id | inputfieldid | userid | value
> 1 1 2 John
> 2 2 2 Smith
> 3 3 2 [EMAIL PROTECTED]
>
> I am trying to come up with a query
I have the following table schema in MySQL 4.1.18 which I didn't
create, but have to work with.
CREATE TABLE `phplog_userinput` (
`id` int(11) NOT NULL auto_increment,
`inputfieldid` int(11) NOT NULL default '0',
`userid` int(11) NOT NULL default '0',
`value` varchar(150) NOT NULL defau
Please reply to the list, rather than to me, personally. Keeping the thread
on the list improves your odds of geting a solution, and allows others with
similar questions to see the answers.
Marco wrote:
Michael Stassen wrote:
What do you mean, it doesn't work?
Michael
Marco wrote:
The query
>
What do you mean, it doesn't work?
Michael
Marco wrote:
The query
> select * from a join b on a.x = b.y;
works on mySQL 3.23.56 but doesn't work on mySQL 3.23.58.
I had to change it in
> select * from a,b where a.x = b.y;
Is it a well-known behavior or is it a bit strange?
Thanks,
Marco
--
MySQL
27 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Join syntax diff 3.23 to 4.x?
>
>
> Try changing "JOIN list_states " to "INNER JOIN list_states "
>
> Looks like the earlier version didn't like your (synonymous) wording.
>
> >
Doh! You are so right. Thanks for the help. Got so used to not needing the
INNER word that I forgot all about it.
-Original Message-
From: Kevin Fries [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 1:27 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Join syntax diff
Try changing "JOIN list_states " to "INNER JOIN list_states "
Looks like the earlier version didn't like your (synonymous) wording.
> -Original Message-
> From: Jack Dare [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 14, 2003 8:35 AM
> To: [EM
Is there something about 3.23 that makes this illegal? It is fine on 4.012.
SELECT [lots of columns]
FROM new_people p LEFT JOIN new_address ad ON p.address_id = ad.id
JOIN list_states ls ON ad.state = ls.id
WHERE p.company_id = 1
Will some minor rewording help it run on both versions OK?
--
M
: Tuesday, March 04, 2003 4:58 PM
To: Bob Ramsey
Cc: [EMAIL PROTECTED]
Subject: Re: help with join syntax
Hi.
This is not at all an answer to your problem,
and perhaps you're already aware of my tip:
I usually use phpMyAdmin and paste my SQL statements
in there to see what is causing the
At 03:57 PM 3/4/2003, Martin Ostlund wrote:
I usually use phpMyAdmin
Thanks for the tip. Unfortunately it isn't my server and they haven't
finished installing phpMyAdmin on it yet. That's why I usually make odbc
connections in access and build the queries graphically. But it just keeps
cho
Hi.
This is not at all an answer to your problem,
and perhaps you're already aware of my tip:
I usually use phpMyAdmin and paste my SQL statements
in there to see what is causing the error, and when it works
you get a pretty good picture of how your "virtual" table
looks like.
Just my 2 cents.
Hi,
I have the following tables:
mysql> describe lawfac_pub;
++--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-+---+
| hawkid | varchar(16) | | PRI | |
same results and both varying between .01, .02 seconds to execute.
6 of one half dozen of another or is there an advantage to one?
My guess is that the second syntax is preferred given the reduced row count
for events in it's explain table.
The first statement uses left joins, the second use's Bre
I would like to return rows, with specific columns, for each individual in
my NAMES table, with address and e-mail if these exist. Thought I had the
syntax down but I'm getting NULL results where I know there is data. I'm
used to using SQL Server shortcut * for outer joins, guess that's catching
* yan zhang
> My MySQL LEFT JOIN Syntax as following is wrong? I
> cannot get the right result.
What result do you get?
> SELECT name, email form T1 LEFT JOIN T2 ON
> T1.Snum=T2.Bnum
Except from the typo form -> FROM, this looks like a valid statement. Do you
get an error?
care of the details as you
develop the query that you want.
i use it, but it seems to be especially
beneficial to newcomers.
>
> Hi there,
> My MySQL LEFT JOIN Syntax as following is wrong? I
> cannot get the right result.
> SELECT name, email form T1 LEFT JOIN T2 ON
>
Hi there,
My MySQL LEFT JOIN Syntax as following is wrong? I
cannot get the right result.
SELECT name, email form T1 LEFT JOIN T2 ON
T1.Snum=T2.Bnum
T1(Snum,name,email,address)
T2(Bnum, notes, time)
I wnat ot get the result(name, email, notes).
Any suggestion, comments
* andy
> thanx for your help. Anyhow this statement does not return the wanted
> fields.
>
> I would like to return the website and the signature of the
> user, but only
> if those values are available. There might be none of them available, but
> maybe 1 or even both.
>
> this query:
> SELECT
>
hey are there.
Thanx for your help,
Andy
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Cc: "andy" <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 3:56 PM
Subject: Re: Problem with join syntax
>
* andy <[EMAIL PROTECTED]>
> thank you roger for your reply.
>
> I am wondering how to form the stmt if I do already know the user_id
>
> I tryed this, but it does not work though. Anyhow there has to be a from
> field. But on which table?
>
> SELECT w.website, c.comment
>LEFT JOIN user_websit
Hi there,
I have some trouble with the syntax of join query and some perfomance isues.
I did split my data due to the rules of normalisation. So there is a website
table and a comment table and I would like to find out if the user with the
id '10215' has a stored comment or website.
Here is my
Hello All,
I have a LEFT JOIN nested inside an INNER JOIN that generates a mySQL
syntax error. I'm new to mySQL so I wonder if anyone could help me
understand the problem. The query runs fine under PostgreSQL, MS SQL, and
MS Access.
SELECT
Recording.Entry, InstCode.InstType, Recording
Vadim,
Monday, April 29, 2002, 7:10:27 PM, you wrote:
V> My company migrated to MySQL a few months ago from Sybase Adaptive
V> Server Anywhere. Where I'm very impressed with the performance and the
V> simplicity of management I find its very difficult, however, to run
V> regular updates or delete
Greetings:
My company migrated to MySQL a few months ago from Sybase Adaptive
Server Anywhere. Where I'm very impressed with the performance and the
simplicity of management I find its very difficult, however, to run
regular updates or deletes because joins are not supported on delete and
update
-Original Message-
From: Vadim [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 27, 2002 4:49 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: I need an example on DELETE /UPDATE with JOIN syntax
Greetings:
My company migrated to MySQL a few mo
Greetings:
My company migrated to MySQL a few months ago from Sybase Adaptive
Server Anywhere. Where I'm very impressed with the performance and the
simplicity of management I find its very difficult, however, to run
regular updates or deletes because joins are not supported on delete and
update
Hi.
On Mon, Mar 11, 2002 at 09:42:01AM -0500, [EMAIL PROTECTED] wrote:
>
> When I call the following PHP script, $qry_1 doesn't work (No query # 1!).
>
> $result_1=mysql_query($qry_1,$connection) or die ("No query # 1!");
At first glance, I don't see any error. But change the previous line
to
When I call the following PHP script, $qry_1 doesn't work (No query # 1!).
DONE";
flush();
exit;
?>
Thank you!
Anthony F. Rodriguez
([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (th
On Wednesday 21 November 2001 03:01, James O'Brien wrote:
> I have been trying to perform a join with several tables and I am having no
> joy.
error messages would increase the understanding of exactly what joy
you aren't having ;-)
> Can some one send me a query (just a select * is fine) for th
I have been trying to perform a join with several tables and I am having no
joy.
Can some one send me a query (just a select * is fine) for these tables
the ID's i'm using below aren't the real column names but they will do for
the purpose of this email.
select * from
table1 left join table2 on
MySQL uses the LEFT JOIN, RIGHT JOIN Syntax ...
RTFM: http://www.mysql.com/doc/J/O/JOIN.html
> -Ursprüngliche Nachricht-
> Von: Bruce Stewart [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 16. Juli 2001 11:54
> An: Mysql-Help (E-mail)
> Betreff: Outer join syntax
Hi all,
MySQL doesn't support nested subqueries, I know, and I also understand that
the same results can be achieved through outer joins (Left join, Right join
and WHERE IS [NOT] NULL).
Also, inner joins can be expressed either in the FROM clause or the WHERE
clause.
My question is: Can outer j
.1443|
||
--
|__|__|
|| ||
ooO Ooo
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 12:58 PM
To: Werner Stuerenburg
Cc: [EMAIL PROTECTED]
Subject: Re: Join syntax
I have two databases (db1 e db2) on different hosts (host1 e host
This topic really interested me.
Can an expert of the list explain a good approach handle distributed system
with distributed databases?
thanks
siomara
>From: <[EMAIL PROTECTED]>
>To: Werner Stuerenburg <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: Join s
RAMOS RODNEYR/Embratel@Embratel
cc: [EMAIL PROTECTED]
D]
> Cc: [EMAIL PROTECTED]
> Subject: Fwd: Join syntax
>
>
> Is it possible to join two tables from different databases that are located
> on different hosts?
>
> Thanks,
>
> Rodney
>
>
>
> -
&
As it seems, it is not possible. You would have to have a
connection which talks to two databases at once, which may not be
possible at all, at least create numerous problems.
But I think it should be possible to create a temporary table in
db 2 and copy the table from db1 into it, then do a join
Is it possible to join two tables from different databases that are located
on different hosts?
Thanks,
Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Is it possible to join two tables from different databases that are located
on different hosts?
Thanks,
Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Mon, Jul 09, 2001 at 09:29:00PM -0300, Rodney A. Ramos wrote:
>
> Is it possible to join two tables from different databases that are
> located on different hosts?
Nope.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454C
Is it possible to join two tables from different databases that are located
on different hosts?
Thanks,
Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Is it possible to join two tables from different databases that are located
on different hosts?
Thanks,
Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
> Is it possible to join two columns from different databases
Yes.
> located on differents hosts?
No. Why do you want to do this?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
Is it possible to join two columns from different databases located on
differents hosts?
Thanks,
Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
inal Message -
> From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
> To: "MySQL" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 27, 2001 2:47
> Subject: Conversion from Access JOIN syntax to MySQL JOIN syntax...
>
> > Yes, I've read the
2:47
Subject: Conversion from Access JOIN syntax to MySQL JOIN syntax...
> Yes, I've read the docs on JOIN syntax, and search the list archives for
> similar information.
>
> I have this query:
>
> SELECT leg_activity.activity_date, leg_transitions.trans_desc,
> leg_text.le
Yes, I've read the docs on JOIN syntax, and search the list archives for
similar information.
I have this query:
SELECT leg_activity.activity_date, leg_transitions.trans_desc,
leg_text.leg_version, body_list.body_name
FROM (((leg_version_hist RIGHT JOIN (leg_comm_hist RIGHT JOIN leg_act
Here it goes. This is a small schema of the two tables.
Table Employees
i_recid = auto increment UNIQUE KEY
First Name
Last Name
ETC.
Table Contracts
sales_rep = e.i_recid
Contract Date = date of contract
Office = office
So here is what i am trying to do.
Run a
tblc.* from tblb left join tblc on
tblb.flda = tblc.flda
hope this helps.
Jack :-)=
- Original Message -
From: "Willie Klein" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 2:20 PM
Subject: Join syntax
> Hi all:
> I think what I want
Hi all:
I think what I want to do is join tables in a select statement but I'm not
having any luck.
I'm using MySQL 3.22 PHP and apache on RH6.2
I have an application that has multiple tables that customers upload order
data to. People who look at this data can see their orders from each table
in
59 matches
Mail list logo
