Jump to content

Search the Community

Showing results for tags 'self-join'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 1 result

  1. I've found an issue doing a left-outer self-join. I can't get any criteria to work for what should be a simple left join; does anyone have any ideas? One table, relevant columns are:CID (Number) - ID number to join with other tables (other tables not relevant in this instance, relationship has not been defined in Caspio)VID (Text[255]) - Name of the Vendor usedEndDate (Date/Time) - Date that the relationship with the Vendor endedLet's have 3 people:John Doe - CID 1Billy Bob - CID 2Fat Joe - CID 3Table Enteries are as follows:1, HR, *null*1, Surefire, *null*1, Vantage, *null*2, HR, 01/01/20162, Surefire, 01/01/20163, HR, *null*3, Vantage, *null*Table should join to itself (left outer) with the CID as the relationship join. What I want to see is anyone with a *null* value for the HR end date and their corresponding Surefire information. View should populate as:1, HR, *null*, 1, Surefire, *null*3, HR, *null*, *null*, *null*, *null*I can't get the criteria right to do this. When I restrict the criteria for the self-join to only join if the right table VID entry is "Surefire" it restricts all the results by that field. The view I end up with is:1, HR, *null*, 1, Surefire *null*
×
×
  • Create New...