Help me about Select in mySQL
Posted: Sat May 17, 2003 11:31 pm
I want to excute select cross query in mySQL.
I have the following table:
tblTest (Id Int, Memory Varchar(50), Content Text, User Varchar(2))
Primary key(Id, Memory)
I insert some records into this table:
Insert into tblTest Values(1, 'AAA', 'Content AAA1', 'usr1'),
Values(1, 'BBB', 'Content BBB1', 'usr1'),
Values(1, 'CCC', 'Content CCC1', 'usr1')
Insert into tblTest Values(2, 'AAA', 'Content AAA2', 'usr2'),
Values(2, 'BBB', 'Content BBB2', 'usr2'),
Values(2, 'CCC', 'Content CCC2', 'usr2')
.........................
I want excute cross query that result of that query is:
Fields: Id AAA BBB CCC User
Record 1: 1 Content AAA1 Content BBB1 Content CCC1 usr1
Record 2: 2 Content AAA2 Content BBB2 Content CCC2 usr2
......... ....................................................................................
How "Select query" do I can write?
Please help me!
Thanks!
I have the following table:
tblTest (Id Int, Memory Varchar(50), Content Text, User Varchar(2))
Primary key(Id, Memory)
I insert some records into this table:
Insert into tblTest Values(1, 'AAA', 'Content AAA1', 'usr1'),
Values(1, 'BBB', 'Content BBB1', 'usr1'),
Values(1, 'CCC', 'Content CCC1', 'usr1')
Insert into tblTest Values(2, 'AAA', 'Content AAA2', 'usr2'),
Values(2, 'BBB', 'Content BBB2', 'usr2'),
Values(2, 'CCC', 'Content CCC2', 'usr2')
.........................
I want excute cross query that result of that query is:
Fields: Id AAA BBB CCC User
Record 1: 1 Content AAA1 Content BBB1 Content CCC1 usr1
Record 2: 2 Content AAA2 Content BBB2 Content CCC2 usr2
......... ....................................................................................
How "Select query" do I can write?
Please help me!
Thanks!


