anders thoresson schrieb:
I'm building a planning system for a newspaper. Article ideas are
defined as articles with no deadline, no publication date or no reporter
assigned. I wan't to show all entries from table un_article that matches
those three criterias.
I have three tables:
CREATE TABLE
Charles Kline wrote:
I am fairly new to SQL and this is a really complex query for me.
Possibly more complex than necessary. Must you have a separate column
for each of the areas? If you don't mind having them all in a single
column, the query becomes simple and efficient:
SELECT p.fname, p.lna
sql,query
I have a table with the following structure:
CREATE TABLE cartconfig_module (
UserID int(10) unsigned NOT NULL default '0',
GroupID int(10) unsigned NOT NULL default '0',
SiteID int(10) unsigned NOT NULL default '0',
Perms enum('Modify','View','Deny') NOT NULL default 'View',
Paul Mallach writes:
> But I simply can't find a (good) query without using a subselect. The problem
> is that I have to check, wheter the live_from value ist the maximum for all
> the versions of this content-piece.
Since what you want to put in a subselect will return a
single value you cou
