join

sorry for the "stupid" question.
if I have these tables:

A B
2 1
1 2
7 5
2 7


A JOIN B is:

2 2
7 7

or not??

thanks

On Thu, 31 Jan 2008 16:25:41 +0100, <anarchix85@gmail.com> wrote:

> sorry for the "stupid" question.
> if I have these tables:
>
> A B
> 2 1
> 1 2
> 7 5
> 2 7
>
>
> A JOIN B is:
>
> 2 2
> 7 7
>
> or not??

Depends on how you join....
The way you pose it, I'd say it's rather:

2 2
1 1
7 7
2 2
--
Rik Wasmus

anarchix85@gmail.com <anarchix85@gmail.com> wrote in
<071db156-69d5-4872-9987-4ff4f1a28157@e10g2000prf.googlegroups.com>:
> if I have these tables:
>
> A B
> 2 1
> 1 2
> 7 5
> 2 7
>
> A JOIN B is:
>
> 2 2
> 7 7
>
> or not??

mysql> SELECT * FROM A JOIN B;
+-------+-------+
| value | value |
+-------+-------+
| 2 | 1 |
| 1 | 1 |
| 7 | 1 |
| 2 | 1 |
| 2 | 2 |
| 1 | 2 |
| 7 | 2 |
| 2 | 2 |
| 2 | 5 |
| 1 | 5 |
| 7 | 5 |
| 2 | 5 |
| 2 | 7 |
| 1 | 7 |
| 7 | 7 |
| 2 | 7 |
+-------+-------+
16 rows in set (0.03 sec)

--
<>There is no phenotype</>

anarchix85@gmail.com wrote:
> sorry for the "stupid" question.
> if I have these tables:
>
> A B
> 2 1
> 1 2
> 7 5
> 2 7
>
>
> A JOIN B is:
>
> 2 2
> 7 7
>
> or not??
>
> thanks


Why ask stupid questions and spend some time testing and using this new
tool on the internet called a search engine... there is an old acronym
that most people like you seem to have forgotten -- RTFreakinM...