Legolas Woodland <[EMAIL PROTECTED]> writes: > Hi > Thank you for reading my post. > imagine that i have : > select count(userID) ,count (siteID) from users,websites > > it will show one record that contain two columns , each column > represent one of the count value > now i want to show two record with one column , indeed i need this to > pass the query to a charting system . the chart will just use first > column of each rows. > so i need to have two rows with one column to use that charting system.
You could try this SQL statement: SELECT COUNT(userID) FROM users UNION SELECT COUNT(siteID) FROM websites -- Knut Anders
