Opened 2 years ago

Last modified 2 years ago

#11 closed suggestion

De DB functies — at Version 1

Reported by: Bart Owned by: Bart
Priority: blocker Milestone:
Component: db_schema Version: 1.0
Keywords: Cc:

Description (last modified by Bart)

identity(){
FROM ads
WHERE tags == query(SELECT tags FROM publisher WHERE property = Referrer )
}

Change History (1)

comment:1 by Bart, 2 years ago

Description: modified (diff)
SELECT ads.ad_id FROM ads JOIN tags ON tags.ad_id=ads.ad_id WHERE
	tags = (SELECT tags FROM publisher WHERE property = Referrer )

foreign table publisher needs to be created

Note: See TracTickets for help on using tickets.