9
>
>> On Aug 4, 2015, at 17:33, Wm Mussatto wrote:
>>
>>> On Tue, August 4, 2015 11:19, Ryan Coleman wrote:
>>> I have been a MySQL user and supporter for over a decade (since 2001)
>>> and
>>> I am almost ashamed to admit that I haven’t the
:19, Ryan Coleman wrote:
>> I have been a MySQL user and supporter for over a decade (since 2001) and
>> I am almost ashamed to admit that I haven’t the faintest idea on how to do
>> joins and unions.
>>
>> I have a specific query I would love to run…
>>
>>
On Tue, August 4, 2015 11:19, Ryan Coleman wrote:
> I have been a MySQL user and supporter for over a decade (since 2001) and
> I am almost ashamed to admit that I haven’t the faintest idea on how to do
> joins and unions.
>
> I have a specific query I would love to run…
>
> I
I have been a MySQL user and supporter for over a decade (since 2001) and I am
almost ashamed to admit that I haven’t the faintest idea on how to do joins and
unions.
I have a specific query I would love to run…
I have two tables, one with Unique data (“images”) and one with corresponding
Parallel Universe* now features Parallel Network Query (Distributed Query)
which joins tables from multiple servers in the network with unprecedented
speed.
Parallel Network Query may also be used to speed up slow server by
distributing tables of the query to multiple servers for processing which
t; -Original Message-
> From: Jeffrey Grollo [mailto:grol...@gmail.com]
> Sent: Tuesday, July 10, 2012 2:50 PM
> To: mysql@lists.mysql.com
> Subject: Composite Index Usage in Joins
>
> Hi,
>
> I'm attempting to optimize a join and am having a difficult time usin
On Wed, Jul 11, 2012 at 5:30 PM, Sergei Petrunia wrote:
> I can provide a refutation. Ability to make a combined index access of
>
> 1. Equality with a non-constant: t.sec_id= p.sec_id
> 2. non-equality comparison with constants, trade_time IN ('2012-07-01',
> '2012-07-02')
>
> has been discussed
Thanks for the guidance and references, Shawn.
On Wed, Jul 11, 2012 at 3:37 PM, Shawn Green wrote:
>
> Ranged scans only happen for the last portion of an index being used. OR
> queries (or those using IN) can also only be applied to the last part of an
> index search. This means that if you are
On Tue, Jul 10, 2012 at 05:50:07PM -0400, Jeffrey Grollo wrote:
> Hi,
>
> I’m attempting to optimize a join and am having a difficult time using
> multiple columns from a composite index. The second column of the composite
> key is being used when tested for equality, but not for IN or BETWEEN
> c
On 7/10/2012 5:50 PM, Jeffrey Grollo wrote:
Hi,
I’m attempting to optimize a join and am having a difficult time using
multiple columns from a composite index. The second column of the composite
key is being used when tested for equality, but not for IN or BETWEEN
criteria.
As an example, say t
Hi,
I’m attempting to optimize a join and am having a difficult time using
multiple columns from a composite index. The second column of the composite
key is being used when tested for equality, but not for IN or BETWEEN
criteria.
As an example, say that I’m searching two tables: portfolio and tr
, 2012 5:20 PM
To: mysql@lists.mysql.com
Subject: Re: forcing mysql to use batched key access (BKA) optimization for
joins
>>>> 2012/04/10 15:58 -0400, Stephen Tu >>>>
select
c_custkey,
c_name,
sum(l_extendedprice * (100 - l_discount)) as revenue,
c_acctba
Hi Stephen,
2012/04/10 15:58 -0400, Stephen Tu
>| id | select_type | table| type | possible_keys | key
>| key_len | ref | rows|
>Extra |
>++-+--++-
2012/04/10 15:58 -0400, Stephen Tu
select
c_custkey,
c_name,
sum(l_extendedprice * (100 - l_discount)) as revenue,
c_acctbal,
n_name,
c_address,
c_phone,
c_comment
from CUSTOMER_INT, ORDERS_INT, LINEITEM_INT, NATION_INT
where
c_custkey = o_custkey
and l_orderke
-0987
-Original Message-
From: shawn.gr...@sun.com [mailto:shawn.gr...@sun.com]
Sent: December 12, 2009 4:39 PM
To: Terry Van de Velde
Cc: mysql@lists.mysql.com
Subject: Re: Multiple joins from same table?
Terry Van de Velde wrote:
> Good Day,
>
> I am attempting to do something new (to
Terry Van de Velde wrote:
Good Day,
I am attempting to do something new (to me) with MySQL. I am looking to have
my query return with the value in the visitor and home columns replaced with
the corresponding team name from the teams table. schedule.visitor and
schedule.home are essentially fore
Terry Van de Velde wrote:
Good Day,
I am attempting to do something new (to me) with MySQL. I am looking to have
my query return with the value in the visitor and home columns replaced with
the corresponding team name from the teams table. schedule.visitor and
schedule.home are essentially
Good Day,
I am attempting to do something new (to me) with MySQL. I am looking to have
my query return with the value in the visitor and home columns replaced with
the corresponding team name from the teams table. schedule.visitor and
schedule.home are essentially foreign keys to teams.team_no
Jim:
> A view is no more or less efficient that the queries that
> make it up. Each
> time you invoke the view, you repeat all the joins.
That is what I was afraid of. With the large number
of tables I have, the joins are going to take a lot
of cycles to run.
> Your solution of
A view is no more or less efficient that the queries that make it up. Each
time you invoke the view, you repeat all the joins.
A join could be more efficient only if you go to a lot of effort to ensure
it forms the most efficient join(s) of the underlying tables.
Your solution of the summary
Hello:
I have a database with over 60 tables with thousands
to millions or rows in each.
I want to develop a summary of the data joined across
all the tables.
I can do this with a view, but I am concerned it will
take a lot of resources to perform all the joins required
by the view. Is a view
Dear Michail and Sergey,
Thank you very much for your responses and kind suggestions!
On 29.10.2009, at 16:53, Sergey Petrunya wrote:
this makes it clear that index on O1.tsn will not be useful. You
need indexes
on parent_tsn column.
mysql> alter table taxonomic_units1 add index (parent_t
NULL | 483305 | |
++-+---+--+---+--+-+--++---+
6 rows in set (0.00 sec)
What is wrong with this query? Or is it a problem of all adjacency
list models?
Is there a way to get columns indexed using self-joins?
Thanks,
Olga
--
MySQL General Mailing
On Thu, Oct 29, 2009 at 07:53:25PM +0300, Sergey Petrunya wrote:
> ... taxonomic_units1 AS O1
> LEFT OUTER JOIN taxonomic_units1 AS O2
> ON O1.tsn = O2.parent_tsn
>
> current optimizer has only one option(*): use Nested-Loops Join algorthm, with
> the outer table being the first one. That is,
| NULL | NULL|
> NULL | 483305 | |
> | 1 | SIMPLE | O6| ALL | NULL | NULL | NULL|
> NULL | 483305 | |
> +----+-+---+--+---+--+-
> +--++---+
> 6 rows in set (0.00 sec)
>
Thanks Kabel,
Not sure if this is the exact problem you're trying to solve, but
this helped
me in a similar situation.
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Yes, I have seen this article before, and it is really nice. However
they do not discuss any optimizat
Not sure if this is the exact problem you're trying to solve, but this helped
me in a similar situation.
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
kabel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
305 | |
++-+---+--+---+--+-
+--++---+
6 rows in set (0.00 sec)
What is wrong with this query? Or is it a problem of all adjacency
list models?
Is there a way to get columns indexed using self-joins?
Thanks,
Olga
--
MySQL General Mailing List
now **exactly** what you’re sending to mysql.
>
>
>
> Regards,
>
> Gavin Towey
>
>
>
> *From:* Victor Subervi [mailto:victorsube...@gmail.com]
> *Sent:* Thursday, October 01, 2009 3:04 PM
>
> *To:* Gavin Towey; mysql@lists.mysql.com
> *Subject:* Re: Nested Join
g the query you're building to a string, then printing it out so you
know *exactly* what you're sending to mysql.
Regards,
Gavin Towey
From: Victor Subervi [mailto:victorsube...@gmail.com]
Sent: Thursday, October 01, 2009 3:04 PM
To: Gavin Towey; mysql@lists.mysql.com
Subject: Re: Nested Jo
Well, your syntax is *exactly* what I had (with a few cosmetic changes).
I've been over the MySQL manual on joins with no luck. I'll read over your
resources tonight. Any other ideas would be appreciated.
Thanks,
V
On Thu, Oct 1, 2009 at 4:49 PM, Gavin Towey wrote:
> Victor,
>
at on p.Category=cat.ID
Make your code produce the above, and you should be fine. I suspect you don't
need LEFT JOIN there, an inner join will suffice.
For more info on joins:
http://hashmysql.org/index.php?title=Introduction_to_Joins
For more indepth info:
http://dev.mysql.com/tech-resource
On Thu, Oct 1, 2009 at 4:03 PM, Gavin Towey wrote:
> Joins aren't nested like that, unless you use a subquery. I think you just
> need to remove the parens around the second join.
>
I tried that and no go :(
>
> For better help:
> 1. show the real SQL -- echo the state
Joins aren't nested like that, unless you use a subquery. I think you just
need to remove the parens around the second join.
For better help:
1. show the real SQL -- echo the statement. Most people here don't like
looking at app code because your variables could contain anything.
2
Hi;
I'm new to join statements. Here's my python syntax:
cursor.execute('select * from %s left join products on
%s.Item=products.Item (left join categories on
products.Category=categories.ID);' % (client, client))
I believe it's clear how I want to nest, but I don't know how to repair my
syntax
been going well so far, and several ColdFusion pages written already.
Need to do one for a Purchase Order Report for ...
- given SupplierCode
- given StartDate and EndDate of Orders
My problem is in the CFquery - understanding what JOINS to use and in what
order to use them.
Which
veral ColdFusion pages written already.
Need to do one for a Purchase Order Report for ...
- given SupplierCode
- given StartDate and EndDate of Orders
My problem is in the CFquery - understanding what JOINS to use and in what
order to use them.
(it is a MyISAM database --
query - understanding what JOINS to use and in what
order to use them.
(it is a MyISAM database = no constraints)
--
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12908 of my spam emails to date.
Get the free SPAMfighter here:
I have 3 tables that are 1:1 and will always have a row for a given
product,_code & date. If I want to join them together, is it going to be
faster to use an equi join or a left join, or does it matter?
Who cares, they are -different- things symantically, use the correct type of
join for you
On Thu, Mar 12, 2009 at 8:41 AM, mos wrote:
> I have 3 tables that are 1:1 and will always have a row for a given
> product,_code & date. If I want to join them together, is it going to be
> faster to use an equi join or a left join, or does it matter?
>
IIRC:With an inner join the optimizer has
IIRC it does not matter. But you can double-check my opinion with EXPLAIN.
A.
On Thu, Mar 12, 2009 at 11:41 AM, mos wrote:
> I have 3 tables that are 1:1 and will always have a row for a given
> product,_code & date. If I want to join them together, is it going to be
> faster to use an equi joi
I have 3 tables that are 1:1 and will always have a row for a given
product,_code & date. If I want to join them together, is it going to be
faster to use an equi join or a left join, or does it matter?
TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
of JOINs,
to give the following output ...
1) Who is assigned what assets?
2) What maintenance has been carried out on each asset?
3) Which assets have not undergone any maintenance?
4) Who hasn't been assigned any assets?
5) Which assets have not been scheduled for maintenan
gh. In your example, the concat_ws expresion has an
> alias so in the queries result this name will be used instead of the
> expression used to select.
>
> A propos: The problem with your first query was that you were using
> natural joins. Natural joins match up all columns that hav
lauses of your query. It is mostly used to display a proper
column name though. In your example, the concat_ws expresion has an
alias so in the queries result this name will be used instead of the
expression used to select.
A propos: The problem with your first query was that you were using
natu
Nanni wrote:
> Hi Phil,
> you seem quite a bit confused!
>
> I would not step to use joins before understanding the 'simple' logic
> behind,
> otherwise you will be always confused by the syntax.
> There are many, many, many resources (thanks to Tim!)
>
> I
Claudio Nanni wrote:
> Hi Phil,
> you seem quite a bit confused!
>
> I would not step to use joins before understanding the 'simple' logic
> behind,
> otherwise you will be always confused by the syntax.
> There are many, many, many resources (thanks to Tim!)
>
Hi Phil,
you seem quite a bit confused!
I would not step to use joins before understanding the 'simple' logic
behind,
otherwise you will be always confused by the syntax.
There are many, many, many resources (thanks to Tim!)
I will try to give you a simple overview of joins but pleas
I have been searching and searching for a clear and logical explanation
of JOINs and have found nothing that can be reasonably understood.
Perhaps I am dense or from another planet, but nothing seems to fall
into place.
I need to display all the books (with their respective authors and
publishers
OUTER JOIN Plates ON Inventory.ItemType = 'Plates' AND Plates.Id
= Inventory.ItemId
LEFT OUTER JOIN Cups ON Inventory.ItemType = 'Cups' AND Cups.Id =
Inventory.ItemId
LEFT OUTER JOIN Flatware ON Inventory.ItemType = 'Flatware' AND
Flatware.Id = Inventory.ItemId
WHERE
Both times seem a bit long, even if you database has millions of rows.
Can you post and explain of your query? That they are in different
databases should have minimal effect on your query.
Brent
On Oct 3, 2008, at 12:14 PM, mos wrote:
I have two indexed MyISAM tables, each in a separate da
I have two indexed MyISAM tables, each in a separate database. If I do a
left join on the two tables, it takes 2 minutes to return the 5,000 rows.
The same join on similar tables in the same database would take 5-10
seconds. Both databases are on the same drive. So why is it 10x slower when
the
> However, i do not want those join records to be appended, only to return the
> count of records from sales.
>
> Can someone assist me with this? I have tried differance variants of joins
> and none of the results are correct.
>
> Sales tbl doesnt have the companyID, nor d
Cool it's good to know thank you.
On 25/01/2008, Jay Pipes <[EMAIL PROTECTED]> wrote:
> Nope, no difference, AFAIK.
>
> Alex K wrote:
> > Any ideas pertaining this newbie question?
> >
> > Thank you so much,
> >
> >> Hi Guys,
> >>
> >> Is there a performance hit when joining across multiple databa
Nope, no difference, AFAIK.
Alex K wrote:
Any ideas pertaining this newbie question?
Thank you so much,
Hi Guys,
Is there a performance hit when joining across multiple databases as
opposed to joining multiples tables in one database? Suppose the same
tables are available across all database
Any ideas pertaining this newbie question?
Thank you so much,
> Hi Guys,
>
> Is there a performance hit when joining across multiple databases as
> opposed to joining multiples tables in one database? Suppose the same
> tables are available across all databases.
>
> Thank you,
>
> Alex
>
--
MyS
Hi,
I need some urgent for sql query.. It will be great if someone could help
me..
I have ARTICLE, FAVORITE_ARTICLES, RATING Tables apart from other table
USER, CHANNEL, CATEGORY etc
ARTICLE table stores a user's article, FAVORITE_ARTICLES will store a user's
favorite articles, and rating table
Hi Guys,
Is there a performance hit when joining across multiple databases as
opposed to joining multiples tables in one database? Suppose the same
tables are available across all databases.
Thank you,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
Hi all,
I have a query that is not quite producing what I expected:
select
n.nid,
n.title,
DATE_FORMAT(FROM_UNIXTIME(n.created), '%c/%e/%Y') as created,
c.field_product_price_value as price,
d.name,
t.tid,
v.value AS vote_average
from
node n
left join node_revi
Hi,
I found one thread on this that included some people's opinions, but I
haven't been able to find anyone who has actually done some performance
testing to see if there is a cost and what that cost is to doing cross
database joins. I do tend to want to keep everything in one
--- [EMAIL PROTECTED] a écrit :
> tom wang wrote:
> > Hi,
> >
> >
> > First, sorry, I kind of messed of with copy and
> > pasting (it's been a long day) and forgot to strip
> all
> > the useless part (for the sake of explaining my
> > problem) between select and from...
> >
> > SELECT * FROM
tom wang wrote:
Hi,
First, sorry, I kind of messed of with copy and
pasting (it's been a long day) and forgot to strip all
the useless part (for the sake of explaining my
problem) between select and from...
SELECT * FROM projects LEFT OUTER JOIN forums ON
forums.work_id = projects.id AND fo
Hi,
First, sorry, I kind of messed of with copy and
pasting (it's been a long day) and forgot to strip all
the useless part (for the sake of explaining my
problem) between select and from...
SELECT * FROM projects LEFT OUTER JOIN forums ON
forums.work_id = projects.id AND forums.work_type =
'P
tom wang schrieb:
Hi,
I have the following sql request:
SELECT projects.`id` AS t0_r0, projects.`name` AS
[..endless sql..]
Hi Tom,
did you understand that query (in lets say 3 months) if you need to fix
a bug? If not it maybe better to simplify that.
regards
-ralf
--
MySQL General Mai
tom wang wrote:
Hi,
I have the following sql request:
[snipped, for the sake of the children]
As you can see I have two left outerjoins involving
the readerships table:
LEFT OUTER JOIN readerships ON readerships.topic_id =
topics.id
and
LEFT OUTER JOIN readerships readerships_topics ON
rea
Hi,
I have the following sql request:
SELECT projects.`id` AS t0_r0, projects.`name` AS
t0_r1, projects.`abbreviated_name` AS t0_r2,
projects.`producer` AS t0_r3, projects.`tel_1` AS
t0_r4, projects.`tel_2` AS t0_r5, projects.`recital`
AS t0_r6, projects.`completed_flag` AS t0_r7,
projects.`compl
one that syntax wont work because
> the second join will be trying to join to the first lookup table no the
> main table. Is there a way around this or do I need to just do joins
> using this syntax
> SELECT x, y, z
> FROM table t, lookupA la, lookupB lb
> WHERE t.aID =
need to join more than one that syntax wont work because
the second join will be trying to join to the first lookup table no the
main table. Is there a way around this or do I need to just do joins
using this syntax
SELECT x, y, z
FROM table t, lookupA la, lookupB lb
WHERE t.aID = a.aID
more than one that syntax wont work because
the second join will be trying to join to the first lookup table no the
main table. Is there a way around this or do I need to just do joins
using this syntax
SELECT x, y, z
FROM table t, lookupA la, lookupB lb
WHERE t.aID = a.aID AND t.bID = b.bID
IN, please write back and include
the output of SHOW CREATE TABLE for the tables, your query, and the
result of EXPLAIN for the query.
[ Triadbrasil ] Filipe Tomita wrote:
Hi all,
First sorry my bad english :)
I having a problem with a large join with 10 tables with 70Gb of text data,
some jo
Hi all,
First sorry my bad english :)
I having a problem with a large join with 10 tables with 70Gb of text data,
some joins executed by index but some others not.
I´m work with HP SERVER (Proliant NL-150) a 2 Xeon 2 Duo with 3Gb Ram and
RAID 0.
When executed to a client with small datasets
It worked in 4.x but does not work in the new syntax. How should I
rewrite it to get the same result?
OK, that was a lie. It works in 5.x as well. I should learn to
describe my problem more accurately as well as RTFM :-(
The correct description of the query in question would have been:
select
I hope someone can clue me in what a syntax of query that produces the
same would look like for MySQL > 5.0.12
Old query meant to list most recent message from each thread, e.g.
select * from messages left join messages as messages_ on
messages.thread = messages_.thread and messages.created <
me
| dispo1 | source2 |
> | 123456781 | NULL | NULL |
> +---+-+-+
>
> I'd appreciate your help.
> Thanks
> Murthy
> Michael Dykman wrote:
> a left join and a right join are 2 very distinct things... It is not
> clear from your text what it is y
---+-+
>
> I'd appreciate your help.
> Thanks
> Murthy
> Michael Dykman <[EMAIL PROTECTED]> wrote:
> a left join and a right join are 2 very distinct things... It is not
> clear from your text what it is you exactly are going for here bu
[EMAIL PROTECTED]> wrote:
a left join and a right join are 2 very distinct things... It is not
clear from your text what it is you exactly are going for here but I
doubt that applying either LEFT or RIGHT to ALL of your (many) joins
is going to give it to you. You need to stop and examine the
rel
a left join and a right join are 2 very distinct things... It is not
clear from your text what it is you exactly are going for here but I
doubt that applying either LEFT or RIGHT to ALL of your (many) joins
is going to give it to you. You need to stop and examine the
relationships between the
I tried the following 2 SQL's and the results are less than satisfactory. The
RIGHT join does not show where disposition is NULL. The LEFT join shows
dispositions as NULL where they shouldn't be. Also the LEFT join generates more
dupes. Any way to fix this?
select cust.first as FIRST, cust
: Tuesday, April 03, 2007 12:15 AM
> To: mysql@lists.mysql.com
> Subject: Joins versus Grouping/Indexing: Normalization Excessive?
>
> So I'm currently designing a database for a web site and
> intra net for my
> campuses student radio. Since I'm not getting paid for this
>
I think you're approaching this from the wrong angle. You'll want to put
the data at the highest level at which it changes.
i.e. If every song on an album is always the same year, put it at the
album level, however, if it changes from song to song on a particular
album, then you want it at the
So I'm currently designing a database for a web site and intra net for my
campuses student radio. Since I'm not getting paid for this and I'm doing
this in my free time I kinda want to take my time and have the system setup
as "perfectly" as any one college student can.
I'm currently debating on
Hi -
I'm having an issue with left joins and multiple tables. I have a table
which is a fairly simple name-value pair table:
create table
{
acnt char(20),
item char(40),
value char (60)
}
I want to pull out all of a subset of the values for a particular account.
It works fo
You're left joining invoices, then left joining receipts. A left join will replicate rows on the left side to match the number of
rows it found in the join, or just leave 1 row with NULL values (as you probably know). This is where your problem is. You were
correct to try to use left
I'm missing something really silly in a query.
I want to produce a list of accounts, the invoices and receipts and the
balance against them.
Simply, there is an accounts table, invoices and receipts.
I want to show the account details, sum(invoices), sum(receipts) and the
balance. There is a sit
I thought I'd pass this on for those of you that have slow table joins. I'm
sure a few of you have already figured this out, but if not, here it is.
I have some slow table joins, namely a 6 table join using a primary integer
index field which takes 15 seconds to pull in 18k rows fr
Are there any hard and fast rules for this? If someone has already
compiled a list I'd love to see it.
For example:
* When a subselect will eliminate duplicates a join might introduce.
Change:
SELECT DISTINCT Acl.*
FROM Acl
JOIN Link ON Link.childID = Acl.ID
JOIN Paths ON Link.parentID
; mysql@lists.mysql.com
Subject: Re: Complex SQL for multiple joins
Also, depending on the number of permissions you are tracking, you could
use a single INT field and do bitwise ORing in your application to
determine permission checks...
Though I usually don't recommend denormalizing the sch
of those should work. I don't know your table structure, so I can't
> get too specific with it.
>
> - Original Message -
> From: "Stephen Orr" <[EMAIL PROTECTED]>
> To:
> Sent: Wednesday, August 30, 2006 7:27 PM
> Subject: Complex SQL f
0, 2006 7:27 PM
Subject: Complex SQL for multiple joins
Hi,
For my current website project I'm developing a fine-grained access control
system.
I have the schema mostly worked out, although it will be having additional
data added to parts of it later.
For the record, I have 6 tables:
Hi,
For my current website project I'm developing a fine-grained access control
system.
I have the schema mostly worked out, although it will be having additional
data added to parts of it later.
For the record, I have 6 tables:
users (contains all my individual users)
usergroups (contains all
On Mon, 2006-08-21 at 07:39 +1000, Chris wrote:
> Ow Mun Heng wrote:
> > On Sun, 2006-08-20 at 19:59 +1000, chris smith wrote:
> >> On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> >>> I'm have a query like so
> >>>
> >>> select
> >>> A,
> >>> index_A
> >>> from
> >>> tableA
> >>> join tableB
>
Ow Mun Heng wrote:
On Sun, 2006-08-20 at 19:59 +1000, chris smith wrote:
On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
I'm have a query like so
select
A,
index_A
from
tableA
join tableB
on tableB.indexA = tableA.indexA
select
A,
index_A
from
tableA
join tableB
on tableB.A = tableA.A
wh
On Sun, 2006-08-20 at 19:59 +1000, chris smith wrote:
> On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> > I'm have a query like so
> >
> > select
> > A,
> > index_A
> > from
> > tableA
> > join tableB
> > on tableB.indexA = tableA.indexA
> >
> >
> > select
> > A,
> > index_A
> > from
> > table
On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
I'm have a query like so
select
A,
index_A
from
tableA
join tableB
on tableB.indexA = tableA.indexA
select
A,
index_A
from
tableA
join tableB
on tableB.A = tableA.A
whcih would be more efficient? using the where clause which uses the
index or
I'm have a query like so
select
A,
index_A
from
tableA
join tableB
on tableB.indexA = tableA.indexA
select
A,
index_A
from
tableA
join tableB
on tableB.A = tableA.A
whcih would be more efficient? using the where clause which uses the
index or the one which isn't index?
--
MySQL General Maili
Brian E Boothe wrote:
hi all
Can someone provide a small project using inner and outter joins with
querys thanks alot
create table t1 (id int);
create table t2 (id int);
This will find everything that has an entry in both tables:
select * from t1 inner join t2;
This will find records that
hi all
Can someone provide a small project using inner and outter joins with
querys thanks alot
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yes it's legal to do multiple join. No, the way you declared you joins is not legal. At the very least it confusing. Do you want to
left join discussion, users and topics, or just memebers?
I'm not sure if MySQL would accept things in that order. I always specifically declare my join
4 -0500
> To: "Steffan A. Cline" <[EMAIL PROTECTED]>
> Cc:
> Subject: Re: Multiple joins
>
> Steffan A. Cline wrote:
>> What am I missing here?
>>
>> select m.*, d.discussion, d.discussion_id, u.user_id, t.topic_id
>> from forums_messages
uot;1";
Is it legal to do multiple joins like this?
Thanks
Steffan
forum_messages does not take part in any selection or any where clause.
You have 5 tables listed, with only 4 of them appearing in 2 disjointed,
and improperly formed joins.
From the comma separated table list after a LE
1 - 100 of 619 matches
Mail list logo