Re: Newbie SQL Question

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Thu, 26 Jul 2007 04:53:30 GMT
Message-ID: <eNVpi.10609$vS1.2383@newsfe16.phx>

chunji08_at_gmail.com wrote in news:1185422352.870669.219710 @x35g2000prf.googlegroups.com:

> Hi there,
> I have a sql question, if someone can help.
>
> Let's say there is a table called "table_map", which has two columns,
> "tablename" and "sql_mapping". If I say:
> " select tablename from table_map where sql_mapping is not null.", I
> will get a list of tables that exist in the same database.
>
> Besides, if I say: "select count(*) from <table name>", I will get the
> rows in one table.
>
> So my Question is is there a way I can combine both SQLs into one,
> that returns me the counts of each table, and the table_names from the
> "table_map".
>
>
> Thanks a lot for the tips.
>
>
> Charlie.
>
>

sure, go ahead & do it.
Now what do you have? Received on Wed Jul 25 2007 - 23:53:30 CDT