Hi All, I have a question: how to use table A.column1 as parameter to query result from table B?
I have two tables : 1. UserStay id candidatePoiIds selectedPoiId 1 101,102,103 100 2. POIs id name address 100 starbuck 100 main st, 101 mcdonalds 101 main st, i want to get all candiate POI's name and address when i fetch User stays, the following code does not work , i also tried Manager with raw SQL, but i dont' know how to pass the candidatePois to manager, can i get the string value of "candidatePois" in model ? class UserStays(models.Model): startTime = models.IntegerField('startTime', max_length=255) candidatePois = models.CharField('CharField', max_length=255) poiRes = POIS.objects.filter(id in F('*candidatePois*') ) // poiRes = POIS.objects.filter(id = 100 ) //print poiRes.name + poiRes.address Thanks Rock -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/722f80db-4069-4e30-a94a-c7d58a9c6c3d%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.