Re: [sqlite] Alternative to * to SELECT most columns?

[Gilles Ganault]

On Sat, 1 Mar 2008 15:35:01 -0500, "P Kishor"
<[EMAIL PROTECTED]> wrote:
>SELECT table1.*, table2.col1
>FROM table1 JOIN table2 ON table1.field10 = table2.field1

Thanks for the tip, but...

1. I want to SELECT all the columns from Table1 and one column from
Table2, but only rows WHERE table1.field10 = 1. The above SELECT
returns all the rows from Table1.

I put the SQL commands in my other reply, so it makes more sense.

2. I can't use the "." notation because PHP doesn't allow this as
column names in associative arrays.

For instance, this doesn't work:

=======
        $dbh = new PDO("sqlite:test.sqlite");

        $sql = "SELECT Table1.*, Table2.name FROM Table1 JOIN Table2 ON
Table1.table2id = Table2.id";

        $rows = $dbh->query($sql);
        while($row = $rows->fetch(PDO::FETCH_ASSOC) ) {
                //Nothing shown...
                echo sprintf("%s<p>",$row['Table1.name']);
        }

        $dbh = null;
=======

So the solution I found is use absolute names for all columns, eg.
Table1_table2id. I should have specified this in the orignal post.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users