<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="slideshow2twoframes.xsl"?>
<xsql:query connection="slideshow" xmlns:xsql="urn:oracle-xsql"
	rowset-element="slideshow" row-element="slide" tag-case="lower"
	slideshowid="id"
	attribute="Title"
	find="%"
>
	SELECT Picture.*
	FROM Picture
	WHERE Picture.Source
	IN (SELECT Slide.Source FROM Slide WHERE Slide.id={@slideshowid})
	AND	Picture.{@attribute} LIKE '%{@find}%'


	
</xsql:query>

<!--

SELECT Picture.*, Slide.Position
	FROM Picture JOIN Slide ON (Picture.Source=Slide.Source)
	WHERE	Slide.id={@slideshowid}
	AND	Picture.{@attribute} LIKE '%{@find}%'
	ORDER BY Slide.Position	

SELECT Picture.*
	FROM Picture, Slide
	WHERE	Picture.Source=Slide.Source
	AND	Slide.id={@slideshowid}
	AND	Picture.{@attribute} LIKE '%{@find}%'
	ORDER BY Slide.Position

 
-->