multiple mysql statements

[owaring]

can i achive the following in 1 mysql statement?
(in plain english)

select field a b & c from 1sttable where field z = 1
select field g & h from 2ndtable where h = a b & c

this is my attempt!:mad:
SELECT name, html FROM pt_core_wwwpages WHERE (
(
name = pt_core_profiles.header
WHERE (pt_core_profiles.profile_id =1)
)
OR
(
name =pt_core_profiles.sidebar
WHERE (pt_core_profiles.profile_id =1)
)
OR
(
name =pt_core_profiles.footer
WHERE (pt_core_profiles.profile_id =1)
))

many thanks

[sagee]

if you just want to run 2 querues that are not neccecery connected you can use UNION.

SQL Statement 1
UNION
SQL Statement 2

example:
SELECT field_name AS new_name FROM tb1
UNION
SELECT field_name_2 AS new_name FROM tb2;