[Virtuoso-users] RDF Views: Defining quad storage, joins?

[Alex Black]

Hi,
 
I'm just getting started with Virtuoso, attempting to create an RDF view
for a relational database I have in SQL Server.
 
I got a basic view setup, where columns map to predicates etc, but now I
want to setup a view that transforms the data into the RDF graph I want.
 
I have two tables I am trying to join: 
 
1. Concept 
    PK_ConceptID
2. Label 
    PK_LabelID, 
    FK_ConceptID,
    Name
 
I'd like to get triples like:
 
<ConceptIRI> skos:altLabel Name
 
How would I do this? I've tried to do it like this, but I get an error
saying "At least one field of a quad map should be map value, not a
constant"
 
sparql
 
 prefix qs: <http://adb/quad_storage/>
 prefix skos: <http://www.w3.org/2004/02/skos/core#>
 
 create quad storage qs:default
   from Source.Source.vwConcept as concept
   from Source.Source.vwLabel as label
  where (^{label.}^.FK_ConceptID = ^{concept.}^.PK_ConceptID)
 {
   create qs:concepts as 
    graph <http://adb/source/data/concepts#>
   {
  conceptSchema:iri_concept(concept.PK_ConceptID) 
       a conceptSchema:Concept;
       skos:altLabel label.Name.
   } .
 
 } .
;
 
 
Thanks!
 
- Alex